<?php
/**
 * Created by PhpStorm.
 * User: R.Ice
 * Date: 2018/10/29
 * Time: 19:12
 * name:按照名称查询员工id
 * url:/erpUser/searchUserByName
 */

$employeeName = $route->bodyParams['employeeName'];

$oesid = $route->bodyParams['oesid'];

$sql = "SELECT `ou_id` FROM `art_oa_user` WHERE `ou_name` = '$employeeName' AND `is_delete` = 0 AND `ou_oesid`= '$oesid'";

$re=$db->mysqlDB->query($sql);

$rs = array("data" => $re);
//返回成功结果
$response->responseData(true, $rs);